-
Re: Can you use Ancestors along with IF(And to check a box?
I have this Idea, I hope it helps. =IF(AND(COUNTIFS(ANCESTORS([Overall Project]@row), 1, ANCESTORS([Level]@row), 2) > 0, [Exec Report Activity]@row = 1), 1, 0) What it does is that it looks at all…1 · -
Re: Automation Workflow - Need Help
Hi Vivien, Seems like a complex workflow. I have an idea to simplify it, and then I hope we can build upon to create a solution. so here my two cents. Idea 1: Do the complex next workflow approver in…1 · -
Re: Can you add a hyperlink reference document in a form?
Hi Suzy, I had the same Issue, I can add the URL as a field, but it is not clickable. so the user have to copy and past it to the browser. However if the URL is static (Same for all), you can add the…1 · -
Re: Is there an automated workflow that populates data in cells based on triggers and conditions?
Hi @Edwina Sampler-Wright, I had similar requirment, however I couldn't fine a workflow that that as of today. I use instead the premiun feature called DataMesh. However is quite trick, because they …1 ·